﻿CREATE PROCEDURE [dbo].[Person_Update]
@PersonID uniqueidentifier
, @ModifiedBy uniqueidentifier
, @GenderID uniqueidentifier
, @RaceID uniqueidentifier
, @ResidentialAddressID uniqueidentifier
, @ContactDetailID uniqueidentifier
, @IdentityTypeID uniqueidentifier
, @FirstName varchar (24)
, @MiddleName varchar (24)
, @Surname varchar (24)
, @Initials varchar (6)
, @IdentityNumber varchar (24)
, @DateOfBirth datetime
, @Age int
AS
BEGIN

UPDATE [dbo].[Person]
SET  [ModifiedBy] = @ModifiedBy
, [GenderID] = @GenderID
, [RaceID] = @RaceID
, [ResidentialAddressID] = @ResidentialAddressID
, [ContactDetailID] = @ContactDetailID
, [IdentityTypeID] = @IdentityTypeID
, [FirstName] = @FirstName
, [MiddleName] = @MiddleName
, [Surname] = @Surname
, [Initials] = @Initials
, [IdentityNumber] = @IdentityNumber
, [DateOfBirth] = @DateOfBirth
, [Age] = @Age
, [ModifiedDate] = GETDATE()
WHERE [Deleted] = 0
AND [PersonID] = @PersonID


END
